Eric Law
Eric Law
Reactions
-
Re: How do I get my events (recurring) to show up once a week in calendar view without manual input?
The easiest way to do this is to have 3 date columns. Last Meeting, Next Meeting, and Oxt Meeting. (you really only need the Last Meeting and Next Meeting column, but I like to have 3) In Next Meetin…1 · -
Re: Not sure why I cant get this to work? TIA for any guidance!
What column are you putting this in? Circular reference means you are using the cell that the formula is posted in, or you are using a cell that another cell is using to sort the formula. Please post…1 · -
Re: COUNTIF cells match in different sheets
Since you've linked both, I will assume the column names to be Sheet 1 and Sheet 2. Create a Match checkbox column and just use =IF(COUNTIF([Sheet 2]:[Sheet 2], [Sheet 1]@row)>0, 1, 0) and that wi…1 · -
Re: Automated copy from row to a new row in the same and single sheet.
@Romano el Polako You can use a helper sheet. What you will do is set up an automation to Copy the row to another sheet. On the helper sheet, you can then set up an automation to Move the row to the …1 · -
Re: recurring annual reminder - contract renewal
@Dhoke you can use that automation for the column you want to run it in. Just build a formula for the date in that column. For instance, if you have an Initial Date column and a Run Date column being…1 ·
